Microsoft Excel Level 1

Outcomes

Participants will learn basic worksheets skills and how to work with data in worksheets. Participants will learn how to use an electronic spreadsheet to create basic data reports

Prerequisites

Windows (95/98/NT 4) introduction, or equivalent knowledge.

What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session

---

Getting Started with Microsoft Excel Working with an Existing Workbook Creating a New Workbook Modifying the Worksheet Working with Columns and Rows Working with Cell Contents Using Formulas Creating and Using Formulas Using Absolute Cell References Using Functions Creating and Using Functions Using the Paste Function Command

Sorting and Filtering Data Sorting Data Filtering Data Formatting Worksheets Formatting Cells Formatting Worksheet Elements Working with Charts Creating Charts Modifying Charts Setting Print Options Changing Page Setup Previewing the Workbook

Performance-based objectives

• Open and move around within and Excel Workbook and learn navigation skills necessary for creating and using Excel spreadsheets.
• Organise columns and rows to accommodate information and edit the contents of cells to organise the information on your worksheet.
• Calculate values by entering formulas into cells and specify an exact address of a cell by creating an absolute cell reference.
• Use functions to create complex formulas.
• Sort information to arrange data in ascending or descending order use filters to display specific information from a list.
• Format cells and worksheet elements to make the workbook consistent and readable.
• Create charts to show data graphically.
• Change the page setup and preview the workbook to define how the printed worksheet appears.